alter table jms_dm.dm_dev_repair_network_monitor_center_summary_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_dev_repair_network_monitor_center_summary_dt;
CREATE EXTERNAL TABLE jms_dm.dm_dev_repair_network_monitor_center_summary_dt
(
    scan_network_code string comment '站点code',
    scan_network_name string comment '站点name',
    date_time         string comment '日期',
    cen_wxin_num      int comment '中心维修入库数',
    cen_wxout_num     int comment '中心维修出库数',
    net_wxin_num      int comment '维修点已入库数',
    net_notwxin_num   int comment '维修点未入库数',
    cen_xfin_num      int comment '中心修复入库数',
    net_wxout_num     int comment '维修点已出库数',
    net_notwxout_num  int comment '维修点未出库数'
) comment '维修点监控报表'
    partitioned by (dt string comment '扫描时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_dev_repair_network_monitor_center_summary_dt'
;